﻿<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <crypto_keys>
    <key id="app_key" type="file" algorithm="rijndael">SharpEntitiesTest.key</key>
  </crypto_keys>

  <string_resources>
    <string resource_id="select_employees_by_city">
      <value version="oracle_9">
        SELECT
        "EmployeeID"
        ,"Employees"."LastName"
        ,"Employees"."FirstName"
        ,"Employees"."Title"
        ,"Employees"."TitleOfCourtesy"
        ,"Employees"."BirthDate"
        ,"Employees"."HireDate"
        ,"Employees"."Address"
        ,"Employees"."City"
        ,"Employees"."Region"
        ,"Employees"."PostalCode"
        ,"Employees"."Country"
        ,"Employees"."HomePhone"
        ,"Employees"."Extension"
        ,"Employees"."Photo"
        ,"Employees"."Notes"
        ,"Employees"."ReportsTo"
        ,"Employees"."PhotoPath"
        FROM "Employees"."Employees"
        where "Employees"."City" = {0}
      </value>
      
      <value version="sql_server_2005">
        SELECT  
         [EmployeeID]
        ,[LastName]
        ,[FirstName]
        ,[Title]
        ,[TitleOfCourtesy]
        ,[BirthDate]
        ,[HireDate]
        ,[Address]
        ,[City]
        ,[Region]
        ,[PostalCode]
        ,[Country]
        ,[HomePhone]
        ,[Extension]
        ,[Photo]
        ,[Notes]
        ,[ReportsTo]
        ,[PhotoPath]
        FROM [Employees]
        where [City] = {0}
      </value>
      
      <default_value>
        SELECT
        [EmployeeID]
        ,[LastName]
        ,[FirstName]
        ,[Title]
        ,[TitleOfCourtesy]
        ,[BirthDate]
        ,[HireDate]
        ,[Address]
        ,[City]
        ,[Region]
        ,[PostalCode]
        ,[Country]
        ,[HomePhone]
        ,[Extension]
        ,[Photo]
        ,[Notes]
        ,[ReportsTo]
        ,[PhotoPath]
        FROM [Employees]
        where [City] = {0}
      </default_value>
    </string>
    

  </string_resources>

</configuration>